Tabela Account

Definicja tabeli Account

Name

Account

Code

Account

Comment

Konta planu kont


Lista kolumn tabeli Account

Name

Code

AccountID

AccountID

AccountTypeID

AccountTypeID

AccountNumber

AccountNumber

StartDT

StartDT

StopDT

StopDT

Year

Year

ParentAccountID

ParentAccountID


Kolumna AccountID tabeli Account

Definicja kolumny AccountID tabeli Account

Name

AccountID

Code

AccountID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID konta


Kolumna AccountTypeID tabeli Account

Definicja kolumny AccountTypeID tabeli Account

Name

AccountTypeID

Code

AccountTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID typu konta w planie kont


Kolumna AccountNumber tabeli Account

Definicja kolumny AccountNumber tabeli Account

Name

AccountNumber

Code

AccountNumber

Data Type

VARCHAR2(128)

Mandatory

Yes

Comment

Numer konta


Kolumna StartDT tabeli Account

Definicja kolumny StartDT tabeli Account

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Poczatek obowiazywania


Kolumna StopDT tabeli Account

Definicja kolumny StopDT tabeli Account

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Koniec obowiazywania


Kolumna Year tabeli Account

Definicja kolumny Year tabeli Account

Name

Year

Code

Year

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Rok


Kolumna ParentAccountID tabeli Account

Definicja kolumny ParentAccountID tabeli Account

Name

ParentAccountID

Code

ParentAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

Element nadrzedny w hierachi konta


Lista kluczy tabeli Account

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Account

Definicja klucza Identifier_1 tabeli Account

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment